/*
 Navicat Premium Data Transfer

 Source Server         : wangjun
 Source Server Type    : MySQL
 Source Server Version : 50619
 Source Host           : localhost
 Source Database       : laravel

 Target Server Type    : MySQL
 Target Server Version : 50619
 File Encoding         : utf-8

 Date: 08/10/2015 09:22:30 AM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `qm_attachment`
-- ----------------------------
DROP TABLE IF EXISTS `qm_attachment`;
CREATE TABLE `qm_attachment` (
  `aid` int(11) NOT NULL AUTO_INCREMENT,
  `app` varchar(50) NOT NULL COMMENT '所属应用',
  `app_id` int(11) NOT NULL DEFAULT '0' COMMENT '资源编号',
  `att_name` varchar(50) NOT NULL COMMENT '附件名称',
  `url` varchar(255) NOT NULL COMMENT '路径',
  `type` char(20) NOT NULL COMMENT '类型',
  `l_url` varchar(255) DEFAULT NULL COMMENT '大图',
  `m_url` varchar(255) DEFAULT NULL COMMENT '中图',
  `s_url` varchar(255) DEFAULT NULL COMMENT '小图',
  `is_del` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否被删除  0:正常  1：已删除',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`aid`),
  KEY `attachment_app_id` (`app`,`app_id`,`created_at`),
  KEY `attachment_is_del` (`is_del`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `qm_attachment`
-- ----------------------------
BEGIN;
INSERT INTO `qm_attachment` VALUES ('1', 'news', '0', 'd7bb27e021a1aae5c796d8b918f3635b.jpg', '/uploads/images/employ/20150806/d7bb27e021a1aae5c796d8b918f3635b.jpg', 'image/jpeg', null, null, null, '0', '2015-08-06 11:12:59', '2015-08-06 11:12:59'), ('2', 'news', '0', 'af39bc84edd3eabb88426fa33d07cd16.jpg', '/uploads/images/employ/20150806/af39bc84edd3eabb88426fa33d07cd16.jpg', 'image/jpeg', null, null, null, '0', '2015-08-06 11:16:02', '2015-08-06 11:16:02'), ('3', 'news', '0', 'fa1fc0a09b8dc100f83b11599c8302c1.jpg', '/uploads/images/employ/20150806/fa1fc0a09b8dc100f83b11599c8302c1.jpg', 'image/jpeg', null, null, null, '0', '2015-08-06 11:16:20', '2015-08-06 11:16:20'), ('4', 'news', '0', '666e3b7743f4763f133bd92a8ab8849a.jpg', '/uploads/images/employ/20150806/666e3b7743f4763f133bd92a8ab8849a.jpg', 'image/jpeg', null, null, null, '0', '2015-08-06 16:41:18', '2015-08-06 16:41:18'), ('5', 'news', '0', 'b058863d26346ea49a798e11e6c88f82.jpg', '/uploads/images/employ/20150806/b058863d26346ea49a798e11e6c88f82.jpg', 'image/jpeg', null, null, null, '0', '2015-08-06 16:46:39', '2015-08-06 16:46:39'), ('6', 'news', '0', 'c5abf341dfdaa8c46f6b7f70ec4a7431.jpg', '/uploads/images/employ/20150806/c5abf341dfdaa8c46f6b7f70ec4a7431.jpg', 'image/jpeg', null, null, null, '0', '2015-08-06 16:47:44', '2015-08-06 16:47:44'), ('7', 'news', '0', '8ae7857e6f97aa68ecfc45cc73a077df.jpg', '/uploads/images/employ/20150806/8ae7857e6f97aa68ecfc45cc73a077df.jpg', 'image/jpeg', null, null, null, '0', '2015-08-06 16:54:40', '2015-08-06 16:54:40'), ('8', 'news', '0', 'bff76b5ea18fcda413e0da1d39ea9048.jpg', '/uploads/images/employ/20150806/bff76b5ea18fcda413e0da1d39ea9048.jpg', 'image/jpeg', null, null, null, '0', '2015-08-06 16:55:34', '2015-08-06 16:55:34'), ('9', 'news', '0', '0c7be74191e3a8abc7a65535946f2b20.jpg', '/uploads/images/employ/20150806/0c7be74191e3a8abc7a65535946f2b20.jpg', 'image/jpeg', null, null, null, '0', '2015-08-06 16:59:27', '2015-08-06 16:59:27'), ('10', 'news', '0', '19853f67d64ce9104842be5c0664dd17.jpg', '/uploads/images/employ/20150806/19853f67d64ce9104842be5c0664dd17.jpg', 'image/jpeg', null, null, null, '0', '2015-08-06 17:03:29', '2015-08-06 17:03:29'), ('11', 'news', '0', '922e44bc6bb94ab11aaf0a937f45c0fa.jpg', '/uploads/images/employ/20150806/922e44bc6bb94ab11aaf0a937f45c0fa.jpg', 'image/jpeg', null, null, null, '0', '2015-08-06 17:28:08', '2015-08-06 17:28:08'), ('12', 'news', '0', 'a5209e4b877408cb46a289582308583c.jpg', '/uploads/images/employ/20150806/a5209e4b877408cb46a289582308583c.jpg', 'image/jpeg', null, null, null, '0', '2015-08-06 17:31:30', '2015-08-06 17:31:30'), ('13', 'news', '0', '55d558d01e83238bace08bffe987c87d.jpg', '/uploads/images/employ/20150807/55d558d01e83238bace08bffe987c87d.jpg', 'image/jpeg', null, null, null, '0', '2015-08-07 14:10:01', '2015-08-07 14:10:01'), ('14', 'news', '0', '448f42446e9af5bb0cfb970513b870b6.jpg', '/uploads/images/employ/20150807/448f42446e9af5bb0cfb970513b870b6.jpg', 'image/jpeg', null, null, null, '0', '2015-08-07 17:16:37', '2015-08-07 17:16:37'), ('15', 'news', '0', 'e77fe92d1770f37f7d6fb77c08fd5af6.jpg', '/uploads/images/employ/20150807/e77fe92d1770f37f7d6fb77c08fd5af6.jpg', 'image/jpeg', null, null, null, '0', '2015-08-07 17:31:26', '2015-08-07 17:31:26'), ('16', 'news', '0', '7f8ffa6b4e81b7bc540126696954f22b.jpg', '/uploads/images/employ/20150807/7f8ffa6b4e81b7bc540126696954f22b.jpg', 'image/jpeg', null, null, null, '0', '2015-08-07 17:33:18', '2015-08-07 17:33:18'), ('17', 'news', '0', '4b7178d051e492ccc423be180d4980bd.jpg', '/uploads/images/employ/20150807/4b7178d051e492ccc423be180d4980bd.jpg', 'image/jpeg', null, null, null, '0', '2015-08-07 17:36:20', '2015-08-07 17:36:20'), ('18', 'news', '0', '67be16e1e6e0a1d7c1878500853f383b.jpg', '/uploads/images/employ/20150808/67be16e1e6e0a1d7c1878500853f383b.jpg', 'image/jpeg', null, null, null, '0', '2015-08-08 18:59:45', '2015-08-08 18:59:45'), ('19', 'news', '0', '5d9658680794e8b09a70afc0a8b12eb6.jpg', '/uploads/images/employ/20150808/5d9658680794e8b09a70afc0a8b12eb6.jpg', 'image/jpeg', null, null, null, '0', '2015-08-08 19:00:38', '2015-08-08 19:00:38');
COMMIT;

-- ----------------------------
--  Table structure for `qm_category`
-- ----------------------------
DROP TABLE IF EXISTS `qm_category`;
CREATE TABLE `qm_category` (
  `cat_id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `cat_name` varchar(50) NOT NULL COMMENT '分类名称',
  `pid` mediumint(8) DEFAULT '0' COMMENT '上级分类',
  `identify` char(15) DEFAULT NULL COMMENT '描述',
  `display_order` mediumint(8) NOT NULL DEFAULT '0' COMMENT '排序',
  `display` tinyint(1) NOT NULL COMMENT '是否显示 0 显示 1 不显示',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `app` varchar(50) NOT NULL COMMENT '所属应用',
  PRIMARY KEY (`cat_id`),
  KEY `cat_pid_display` (`pid`,`display_order`,`display`),
  KEY `cat_dispaly_stime` (`display`,`created_at`,`updated_at`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `qm_category`
-- ----------------------------
BEGIN;
INSERT INTO `qm_category` VALUES ('1', '认证指南', '0', 'toutiao', '0', '0', '2015-08-05 10:28:14', '2015-08-05 10:28:14', 'employ'), ('2', '热点', '0', 'redian', '0', '0', '2015-08-05 10:28:31', '2015-08-05 10:28:31', 'news'), ('3', '国家认证', '1', 'guojiarenzheng', '1', '0', '2015-08-06 18:49:43', '2015-08-06 18:49:43', 'employ'), ('9', '财经类', '3', null, '1', '0', '2015-08-06 19:29:00', '2015-08-06 19:29:00', 'employ'), ('10', '电力类', '3', null, '2', '0', '2015-08-06 21:36:14', '2015-08-06 21:36:14', 'employ'), ('11', '土建类', '3', null, '3', '0', '2015-08-06 21:37:43', '2015-08-06 21:37:43', 'employ'), ('12', '水利类', '3', null, '3', '0', '2015-08-06 21:39:06', '2015-08-06 21:39:06', 'employ'), ('13', '旅游类', '3', null, '5', '0', '2015-08-06 21:42:15', '2015-08-06 21:42:15', 'employ'), ('14', ' 行业认证', '1', null, '2', '0', '2015-08-06 22:27:36', '2015-08-06 22:27:36', 'employ'), ('15', 'IT类', '14', null, '0', '0', '2015-08-07 09:23:57', '2015-08-07 09:23:57', 'employ');
COMMIT;

-- ----------------------------
--  Table structure for `qm_cms_comment`
-- ----------------------------
DROP TABLE IF EXISTS `qm_cms_comment`;
CREATE TABLE `qm_cms_comment` (
  `comment_id` int(11) NOT NULL AUTO_INCREMENT,
  `app_table` varchar(20) NOT NULL COMMENT '资源表名',
  `app_id` int(11) NOT NULL COMMENT '资源编号',
  `user_id` int(11) NOT NULL COMMENT '评论用户编号',
  `title` varchar(100) NOT NULL COMMENT '标题',
  `content` varchar(255) NOT NULL COMMENT '评论内容',
  `to_comment_id` int(11) NOT NULL DEFAULT '0' COMMENT '评论的评论编号',
  `to_user_id` int(11) NOT NULL DEFAULT '0' COMMENT '评论的评论用户',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT ' 0 未审核，1 已审核 ，2 已删除   默认0',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`comment_id`),
  KEY `comment_app_status` (`app_table`,`app_id`,`status`),
  KEY `comment_user_id` (`user_id`),
  KEY `comment_to_comment_id` (`to_comment_id`),
  KEY `comment_to_user_id` (`to_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `qm_cms_jynews`
-- ----------------------------
DROP TABLE IF EXISTS `qm_cms_jynews`;
CREATE TABLE `qm_cms_jynews` (
  `news_id` int(11) NOT NULL AUTO_INCREMENT,
  `cat_id` mediumint(8) NOT NULL DEFAULT '0' COMMENT '分类编号',
  `description` text NOT NULL COMMENT '简介',
  `tools` text NOT NULL COMMENT '工具',
  `content` longtext NOT NULL COMMENT '步骤  序列化字符串',
  `notice` text COMMENT '注意事项',
  `tags` varchar(200) NOT NULL COMMENT '标签',
  `author` varchar(20) DEFAULT NULL COMMENT '作者',
  `from` char(100) DEFAULT NULL COMMENT '来源',
  `status` tinyint(1) DEFAULT '0' COMMENT '状态 0 未发布  1 已发布   2  已删除',
  `user_id` int(11) NOT NULL COMMENT '创建用户编号',
  `display_order` int(10) DEFAULT NULL COMMENT '越大越靠前',
  `top` tinyint(1) DEFAULT NULL COMMENT '置顶  0 非置顶文章  1 置顶文章  默认0',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建用户编号',
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `title` varchar(200) NOT NULL COMMENT '标题',
  PRIMARY KEY (`news_id`),
  KEY `jynews_users_id` (`user_id`),
  KEY `jynews_top` (`top`),
  KEY `jynews_cat_id_diplay` (`cat_id`,`status`,`display_order`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `qm_cms_jynews`
-- ----------------------------
BEGIN;
INSERT INTO `qm_cms_jynews` VALUES ('39', '0', 'a:2:{s:4:\"name\";s:30:\"求职攻略测试数据简介\";s:3:\"img\";a:3:{i:0;s:85:\"http://localhost:81/uploads/images/news/20150805/c0930422d0dc368f453adf8007fdb2f5.jpg\";i:1;s:85:\"http://localhost:81/uploads/images/news/20150805/951080a56ac141e09f93af278bea9c39.jpg\";i:2;s:85:\"http://localhost:81/uploads/images/news/20150805/47096fc7f9376fbbc7a7fde5fb28244e.jpg\";}}', 'a:3:{i:0;s:30:\"求职攻略测试数据工具\";i:1;s:31:\"求职攻略测试数据工具2\";i:2;s:31:\"求职攻略测试数据工具3\";}', 'a:5:{i:0;a:2:{s:4:\"name\";s:36:\"求职攻略测试数据方法步骤\";s:3:\"img\";a:1:{i:0;s:85:\"http://localhost:81/uploads/images/news/20150805/7d8f5c9fddaeed805a121ede4739cfb9.jpg\";}}i:1;a:2:{s:4:\"name\";s:37:\"求职攻略测试数据方法步骤2\";s:3:\"img\";a:3:{i:0;s:85:\"http://localhost:81/uploads/images/news/20150805/5683351afb3f2e27d8a2285d3c6756a2.jpg\";i:1;s:85:\"http://localhost:81/uploads/images/news/20150805/cc9a5ac90595f636cf6a19b0d66763b4.jpg\";i:2;s:85:\"http://localhost:81/uploads/images/news/20150805/2a412aee5b112ec4b13cbc5f47793a97.png\";}}i:2;a:2:{s:4:\"name\";s:37:\"求职攻略测试数据方法步骤3\";s:3:\"img\";a:2:{i:0;s:85:\"http://localhost:81/uploads/images/news/20150805/a28c60c341591fc087faed2fb9a5e410.jpg\";i:1;s:85:\"http://localhost:81/uploads/images/news/20150805/8a2b392748a24d15aade668806c0f155.jpg\";}}i:3;a:2:{s:4:\"name\";s:37:\"求职攻略测试数据方法步骤4\";s:3:\"img\";s:0:\"\";}i:4;a:2:{s:4:\"name\";s:37:\"求职攻略测试数据方法步骤5\";s:3:\"img\";a:1:{i:0;s:85:\"http://localhost:81/uploads/images/news/20150805/b27116cd95714f11ad40955daf60f17d.jpg\";}}}', 'a:2:{i:0;s:36:\"求职攻略测试数据注意事项\";i:1;s:37:\"求职攻略测试数据注意事项2\";}', '标签', 'wangjun', 'xweisoft', '1', '1', null, '1', '2015-08-05 15:17:34', '2015-08-08 18:45:06', '求职攻略测试数据标题');
COMMIT;

-- ----------------------------
--  Table structure for `qm_cms_news`
-- ----------------------------
DROP TABLE IF EXISTS `qm_cms_news`;
CREATE TABLE `qm_cms_news` (
  `news_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(80) NOT NULL COMMENT '标题',
  `cat_id` mediumint(8) NOT NULL DEFAULT '0' COMMENT '分类编号',
  `thumb` int(11) NOT NULL COMMENT '缩略图',
  `description` text NOT NULL COMMENT '摘要',
  `content` longtext NOT NULL COMMENT '内容  文章内容',
  `from` char(100) DEFAULT NULL COMMENT '来源',
  `pagination_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '分页方式   0 不分页，   1自动分页 ，  3 手动分页， 默认0',
  `user_id` int(11) NOT NULL COMMENT '创建用户编号',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态   0 未发布  1 已发布 2  已删除',
  `display_order` int(10) NOT NULL DEFAULT '0' COMMENT '排序，越大越考前',
  `top` tinyint(1) NOT NULL DEFAULT '0' COMMENT '置顶 0 非置顶文章， 1 置顶文章 ，默认0',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`news_id`),
  KEY `news_user_id` (`user_id`),
  KEY `news_top` (`top`),
  KEY `news_cat_id_status` (`cat_id`,`status`,`display_order`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `qm_cms_news`
-- ----------------------------
BEGIN;
INSERT INTO `qm_cms_news` VALUES ('1', '就业指南测试数据', '1', '10', '<p>就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据</p>', '<p>就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据</p>', 'www.xweisoft', '0', '1', '2', '100', '1', '2015-08-06 17:07:11', '2015-08-08 18:55:25'), ('2', '就业指南测试数据', '1', '10', '<p>就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据</p>', '<p>就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据</p>', 'www.xweisoft', '0', '1', '1', '100', '1', '2015-08-06 17:09:20', '2015-08-06 17:09:20'), ('3', '就业指南测试数据', '1', '10', '<p>就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据</p>', '<p>就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据</p>', 'www.xweisoft', '0', '1', '1', '100', '1', '2015-08-06 17:10:10', '2015-08-06 17:10:10'), ('4', '就业指南测试数据', '1', '10', '<p>就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据</p>', '<p>就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据</p>', 'www.xweisoft', '0', '1', '1', '100', '1', '2015-08-06 17:12:08', '2015-08-06 17:12:08'), ('5', '就业指南测试数据', '1', '10', '<p>就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据</p>', '<p>就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据</p>', 'www.xweisoft', '0', '1', '1', '100', '1', '2015-08-06 17:15:33', '2015-08-06 17:15:33'), ('6', '就业指南测试数据', '1', '10', '<p>就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据</p>', '<p>就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据</p>', 'www.xweisoft', '0', '1', '1', '100', '1', '2015-08-06 17:20:21', '2015-08-06 17:20:21'), ('7', '就业指南测试数据', '1', '10', '<p>就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据</p>', '<p>就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据</p>', 'www.xweisoft', '0', '1', '1', '100', '1', '2015-08-06 17:21:20', '2015-08-06 17:21:20'), ('8', '就业指南测试数据', '1', '10', '<p>就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据</p>', '<p>就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据就业指南测试数据</p>', 'www.xweisoft', '0', '1', '1', '100', '1', '2015-08-06 17:22:43', '2015-08-06 17:22:43'), ('9', '第二条测试数据', '1', '11', '<p>第二条测试数据第二条测试数据第二条测试数据第二条测试数据第二条测试数据第二条测试数据第二条测试数据</p>', '<p>第二条测试数据第二条测试数据第二条测试数据第二条测试数据第二条测试数据第二条测试数据第二条测试数据第二条测试数据第二条测试数据第二条测试数据</p>', 'www.xweisoft.com', '0', '1', '1', '80', '1', '2015-08-06 17:28:40', '2015-08-06 17:28:40'), ('10', '第二条测试数据', '1', '11', '<p>第二条测试数据第二条测试数据第二条测试数据第二条测试数据第二条测试数据第二条测试数据第二条测试数据</p>', '<p>第二条测试数据第二条测试数据第二条测试数据第二条测试数据第二条测试数据第二条测试数据第二条测试数据第二条测试数据第二条测试数据第二条测试数据</p>', 'www.xweisoft.com', '0', '1', '1', '80', '1', '2015-08-06 17:29:04', '2015-08-06 17:29:04'), ('11', '第三条测试数据', '1', '12', '<p>第三条测试数据</p>', '<p>第三条测试数据第三条测试数据第三条测试数据第三条测试数据第三条测试数据第三条测试数据第三条测试数据第三条测试数据</p>', 'www.xweisoft.com', '0', '1', '1', '7', '1', '2015-08-06 17:32:14', '2015-08-06 17:32:14'), ('12', '第三条测试数据', '1', '12', '<p>第三条测试数据</p>', '<p>第三条测试数据第三条测试数据第三条测试数据第三条测试数据第三条测试数据第三条测试数据第三条测试数据第三条测试数据</p>', 'www.xweisoft.com', '0', '1', '1', '7', '1', '2015-08-06 17:34:00', '2015-08-06 17:34:00'), ('13', '第三条测试数据', '1', '12', '<p>第三条测试数据</p>', '<p>第三条测试数据第三条测试数据第三条测试数据第三条测试数据第三条测试数据第三条测试数据第三条测试数据第三条测试数据</p>', 'www.xweisoft.com', '0', '1', '1', '7', '1', '2015-08-06 17:36:50', '2015-08-06 17:36:50'), ('14', '第三条测试数据', '1', '12', '<p>第三条测试数据</p>', '<p>第三条测试数据第三条测试数据第三条测试数据第三条测试数据第三条测试数据第三条测试数据第三条测试数据第三条测试数据</p>', 'www.xweisoft.com', '0', '1', '1', '7', '1', '2015-08-06 17:37:45', '2015-08-06 17:37:45'), ('15', '测试财经类数据', '9', '13', '<p class=\"p1\">测试财经类数据简介</p><p><br/></p>', '<p>测试财经类数据内容测试财经类数据内容测试财经类数据内容测试财经类数据内容测试财经类数据内容测试财经类数据内容测试财经类数据内容测试财经类数据内容测试财经类数据内容测试财经类数据内容测试财经类数据内容测试财经类数据内容测试财经类数据内容测试财经类数据内容</p>', 'www.xweisoft.com', '0', '1', '1', '1', '1', '2015-08-07 14:10:41', '2015-08-07 14:10:41'), ('16', '测试的一条数据', '1', '14', '<p>测试的一条数据</p>', '<p>测试的一条数据</p>', 'www.xweisoft.com', '0', '1', '1', '7', '1', '2015-08-07 17:16:53', '2015-08-07 17:16:53'), ('17', '测试的测试', '1', '15', '<p>测试的测试测试的测试测试的测试测试的测试</p>', '<p>测试的测试测试的测试测试的测试测试的测试测试的测试测试的测试测试的测试测试的测试</p>', 'www.xweisoft.com', '0', '1', '1', '5', '1', '2015-08-07 17:31:47', '2015-08-07 17:31:47'), ('18', '测试的测试测试的测试测试的测试测试的测试', '3', '16', '<p>测试的测试测试的测试测试的测试测试的测试测试的测试</p>', '<p>测试的测试测试的测试测试的测试测试的测试测试的测试测试的测试测试的测试测试的测试</p>', 'www.xweisoft.com', '0', '1', '1', '6', '1', '2015-08-07 17:34:03', '2015-08-07 17:34:03'), ('19', '的点点滴滴 分类修改为 旅游类', '13', '17', '<p>撒旦福建师大法律框架撒到了疯狂结束了大家看法</p>', '<p>撒旦福建师大法律框架撒到了疯狂结束了大家看法撒旦福建师大法律框架撒到了疯狂结束了大家看法撒旦福建师大法律框架撒到了疯狂结束了大家看法撒旦福建师大法律框架撒到了疯狂结束了大家看法撒旦福建师大法律框架撒到了疯狂结束了大家看法撒旦福建师大法律框架撒到了疯狂结束了大家看法撒旦福建师大法律框架撒到了疯狂结束了大家看法撒旦福建师大法律框架撒到了疯狂结束了大家看法撒旦福建师大法律框架撒到了疯狂结束了大家看法撒旦福建师大法律框架撒到了疯狂结束了大家看法</p>', 'xweisoft', '0', '1', '1', '4', '1', '2015-08-07 17:36:43', '2015-08-08 23:26:24'), ('20', '认证指南 国家认证 电力类', '1', '18', '<p>认证指南 国家认证 电力类</p>', '<p>认证指南 国家认证 电力类认证指南 国家认证 电力类认证指南 国家认证 电力类认证指南 国家认证 电力类</p>', 'www.xweisoft.com', '0', '1', '1', '1', '1', '2015-08-08 18:59:49', '2015-08-08 18:59:49'), ('21', '认证指南  国家认证 土建类', '11', '19', '<p>认证指南</p>', '<p>认证指南</p>', 'www.xweisoft.com', '0', '1', '1', '9', '1', '2015-08-08 19:01:03', '2015-08-08 23:44:37'), ('22', '的点点滴滴 修改为 电力类', '3', '17', '<p>撒旦福建师大法律框架撒到了疯狂结束了大家看法</p>', '<p>撒旦福建师大法律框架撒到了疯狂结束了大家看法撒旦福建师大法律框架撒到了疯狂结束了大家看法撒旦福建师大法律框架撒到了疯狂结束了大家看法撒旦福建师大法律框架撒到了疯狂结束了大家看法撒旦福建师大法律框架撒到了疯狂结束了大家看法撒旦福建师大法律框架撒到了疯狂结束了大家看法撒旦福建师大法律框架撒到了疯狂结束了大家看法撒旦福建师大法律框架撒到了疯狂结束了大家看法撒旦福建师大法律框架撒到了疯狂结束了大家看法撒旦福建师大法律框架撒到了疯狂结束了大家看法</p>', 'xweisoft', '0', '1', '1', '4', '1', '2015-08-08 23:08:36', '2015-08-08 23:08:36');
COMMIT;

-- ----------------------------
--  Table structure for `qm_cms_news_comm`
-- ----------------------------
DROP TABLE IF EXISTS `qm_cms_news_comm`;
CREATE TABLE `qm_cms_news_comm` (
  `app_id` int(11) NOT NULL,
  `app_table` varchar(20) NOT NULL COMMENT '所属表',
  `groupids_view` varchar(100) DEFAULT NULL COMMENT '阅读权限',
  `read_point` decimal(10,2) DEFAULT NULL COMMENT '阅读费用',
  `paytype` tinyint(1) DEFAULT '0' COMMENT '支付方式  0 积分   1 金币',
  `is_comment` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许评论 0 是 1 否 默认0',
  PRIMARY KEY (`app_table`,`app_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `qm_migrations`
-- ----------------------------
DROP TABLE IF EXISTS `qm_migrations`;
CREATE TABLE `qm_migrations` (
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `qm_migrations`
-- ----------------------------
BEGIN;
INSERT INTO `qm_migrations` VALUES ('2014_10_12_000000_create_users_table', '1'), ('2014_10_12_100000_create_password_resets_table', '1'), ('2015_07_17_140707_add_cashier_columns', '1'), ('2015_07_31_165611_entrust_setup_tables', '1');
COMMIT;

-- ----------------------------
--  Table structure for `qm_news_tags`
-- ----------------------------
DROP TABLE IF EXISTS `qm_news_tags`;
CREATE TABLE `qm_news_tags` (
  `news_id` int(11) NOT NULL,
  `tags_id` int(11) NOT NULL,
  PRIMARY KEY (`news_id`,`tags_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `qm_news_tags`
-- ----------------------------
BEGIN;
INSERT INTO `qm_news_tags` VALUES ('8', '1'), ('8', '2'), ('10', '3'), ('10', '4'), ('14', '7'), ('15', '8'), ('16', '1'), ('17', '1'), ('18', '9'), ('19', '10'), ('20', '11'), ('21', '12'), ('21', '13'), ('22', '10');
COMMIT;

-- ----------------------------
--  Table structure for `qm_password_resets`
-- ----------------------------
DROP TABLE IF EXISTS `qm_password_resets`;
CREATE TABLE `qm_password_resets` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  KEY `password_resets_email_index` (`email`),
  KEY `password_resets_token_index` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `qm_permission_role`
-- ----------------------------
DROP TABLE IF EXISTS `qm_permission_role`;
CREATE TABLE `qm_permission_role` (
  `permission_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `permission_role_role_id_foreign` (`role_id`),
  CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `qm_permissions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `qm_roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `qm_permission_role`
-- ----------------------------
BEGIN;
INSERT INTO `qm_permission_role` VALUES ('1', '1'), ('2', '1'), ('3', '1'), ('4', '1'), ('5', '1'), ('6', '1'), ('7', '1'), ('8', '1'), ('9', '1'), ('10', '1'), ('11', '1'), ('12', '1'), ('13', '1'), ('14', '1'), ('15', '1'), ('16', '1'), ('17', '1'), ('18', '1'), ('19', '1'), ('20', '1'), ('21', '1'), ('22', '1'), ('23', '1'), ('24', '1'), ('25', '1'), ('26', '1'), ('27', '1');
COMMIT;

-- ----------------------------
--  Table structure for `qm_permissions`
-- ----------------------------
DROP TABLE IF EXISTS `qm_permissions`;
CREATE TABLE `qm_permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `display_name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `qm_permissions`
-- ----------------------------
BEGIN;
INSERT INTO `qm_permissions` VALUES ('1', 'myboard', 'myboard', '我的面板', '2015-07-31 17:48:27', '2015-07-31 17:48:27'), ('2', 'content', 'content', '内容管理', '2015-07-31 17:48:27', '2015-07-31 17:48:27'), ('3', 'organization', 'organization', '机构管理', '2015-08-08 11:29:06', '2015-08-08 11:29:09'), ('4', 'enterprise', 'enterprise', '企业招聘', '2015-08-08 11:29:13', '2015-08-08 11:29:15'), ('5', 'bbs', 'bbs', '青苜社区管理', '2015-08-08 11:29:17', '2015-08-08 11:29:20'), ('6', 'users', 'users', '用户管理', '2015-08-08 11:29:23', '2015-08-08 11:29:25'), ('7', 'ads', 'ads', '广告管理', '2015-08-08 11:29:28', '2015-08-08 11:29:30'), ('8', 'system', 'system', '系统设置管理', '2015-08-08 11:29:33', '2015-08-08 11:29:35'), ('9', 'server', 'server', '服务器状态', '2015-08-08 11:29:38', '2015-08-08 11:29:41'), ('10', 'viewServer', 'viewServer', '查看服务器状态', '2015-08-08 11:29:44', '2015-08-08 11:29:46'), ('11', 'ownerInfo', 'owerInfo', '个人信息', '2015-08-08 11:29:49', '2015-08-08 11:29:51'), ('12', 'viewOwerInfo', 'viewOwerInfo', '查看个人信息', '2015-08-08 11:29:54', '2015-08-08 11:29:57'), ('13', 'editOwerInfo', 'editOwerInfo', '修改个人信息', '2015-08-08 11:30:00', '2015-08-08 11:30:01'), ('14', 'editOwerPwd', 'editOwerPwd', '修改密码', '2015-08-08 11:30:04', '2015-08-08 11:30:07'), ('15', 'employ', 'employ', '就业指南', '2015-08-08 11:30:10', '2015-08-08 11:30:12'), ('16', 'viewEmploy', 'viewEmploy', '查看就业指南列表', '2015-08-08 11:30:15', '2015-08-08 11:30:17'), ('17', 'editEmploy', 'editEmploy', '修改/新增就业指南', '2015-08-08 11:30:21', '2015-08-08 11:30:23'), ('18', 'delEmploy', 'delEmploy', '删除就业指南', '2015-08-08 11:30:26', '2015-08-08 11:30:28'), ('19', 'viewEmployCategory', 'viewEmployCategory', '查看就业指南分类', '2015-08-08 11:30:30', '2015-08-08 11:30:32'), ('20', 'editEmployCategory', 'editEmployCategory', '修改/新增就业指南分类', '2015-08-08 11:35:44', '2015-08-08 11:35:46'), ('21', 'teaches', 'teaches', '充电加油', '2015-08-08 11:36:44', '2015-08-08 11:36:46'), ('22', 'viewTeaches', 'viewTeaches', '查看充电加油', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), ('23', 'editTeaches', 'editTeaches', '修改/新增充电加油', '2015-08-08 11:38:01', '2015-08-08 11:38:03'), ('24', 'delTeaches', 'delTeaches', '删除充电加油', '2015-08-08 11:40:38', '2015-08-08 11:40:40'), ('25', 'viewTeachesCategory', 'viewTeachesCategory', '查看充电加油分类', '2015-08-08 11:45:39', '2015-08-08 11:45:41'), ('26', 'editTeachesCategory', 'editTeachesCategory', '修改/新增充电加油分类', '2015-08-08 11:46:05', '2015-08-08 11:46:07'), ('27', 'delTeachesCategory', 'delTeachesCategory', '删除充电加油分类', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
COMMIT;

-- ----------------------------
--  Table structure for `qm_role_user`
-- ----------------------------
DROP TABLE IF EXISTS `qm_role_user`;
CREATE TABLE `qm_role_user` (
  `user_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`user_id`,`role_id`),
  KEY `role_user_role_id_foreign` (`role_id`),
  CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `qm_roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `role_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `qm_users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `qm_role_user`
-- ----------------------------
BEGIN;
INSERT INTO `qm_role_user` VALUES ('1', '1');
COMMIT;

-- ----------------------------
--  Table structure for `qm_roles`
-- ----------------------------
DROP TABLE IF EXISTS `qm_roles`;
CREATE TABLE `qm_roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `display_name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `qm_roles`
-- ----------------------------
BEGIN;
INSERT INTO `qm_roles` VALUES ('1', 'superadmin', '超级管理员', 'User is the owner of a given project', '2015-07-31 17:16:58', '2015-07-31 17:16:58'), ('2', 'admin', '普通管理员', 'User is allowed to manage and edit other users', '2015-07-31 17:16:58', '2015-07-31 17:16:58');
COMMIT;

-- ----------------------------
--  Table structure for `qm_site_menu`
-- ----------------------------
DROP TABLE IF EXISTS `qm_site_menu`;
CREATE TABLE `qm_site_menu` (
  `menu_id` mediumint(6) NOT NULL AUTO_INCREMENT,
  `parent_id` mediumint(6) NOT NULL DEFAULT '0' COMMENT '父菜单id',
  `name` varchar(20) NOT NULL COMMENT '名称',
  `url` varchar(255) DEFAULT NULL COMMENT '路径',
  `description` varchar(150) DEFAULT NULL COMMENT '描述',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态 0 启用  ，1禁用，默认0',
  `display_order` int(10) NOT NULL DEFAULT '0' COMMENT 'display_order',
  `permission_id` int(10) NOT NULL COMMENT '权限编号',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `icon` varchar(100) DEFAULT NULL COMMENT '图标',
  PRIMARY KEY (`menu_id`),
  KEY `menu_permission_status` (`permission_id`,`display_order`,`status`),
  KEY `menu_pid_stime` (`parent_id`,`display_order`,`updated_at`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `qm_site_menu`
-- ----------------------------
BEGIN;
INSERT INTO `qm_site_menu` VALUES ('1', '0', '我的面板', '/admin/index', 'wodemianban', '0', '0', '1', '2015-08-05 17:13:37', '2015-08-05 17:13:37', null), ('2', '0', '内容管理', '/admin/content', 'neirongguanli', '0', '0', '2', '2015-08-05 17:13:37', '2015-08-05 17:13:37', null), ('3', '0', '机构管理', '/admin/organization', 'jigouguanli', '0', '0', '3', '2015-08-05 17:13:37', '2015-08-05 17:13:37', null), ('4', '0', '企业招聘', '/admin/enterprise', 'qiyezhaopin', '0', '0', '4', '2015-08-05 17:13:37', '2015-08-05 17:13:37', null), ('5', '0', '青苜社区', '/admin/bbs', 'qingmushequ', '0', '0', '5', '2015-08-05 17:13:37', '2015-08-05 17:13:37', null), ('6', '0', '用户管理', '/admin/users', 'yonghuguanli', '0', '0', '6', '2015-08-05 17:13:37', '2015-08-05 17:13:37', null), ('7', '0', '广告管理', '/admin/ads', 'guanggaoguanli', '0', '0', '7', '2015-08-05 17:13:37', '2015-08-05 17:13:37', null), ('8', '0', '系统设置', '/admin/setting', 'xitongshezhi', '0', '0', '8', '2015-08-05 17:13:37', '2015-08-05 17:13:37', null), ('9', '1', '服务器状态', '/admin/index/server', 'fuwuqizhuangtai', '0', '0', '9', '2015-08-05 17:20:40', '2015-08-05 17:20:40', 'glyphicon glyphicon-home'), ('10', '1', '个人信息', '/admin/index/owner', 'gerenxinxi', '0', '0', '11', '2015-08-05 17:20:40', '2015-08-05 17:20:40', 'glyphicon glyphicon-user'), ('11', '9', '服务器状态', '/admin/index/server', 'fuwuqizhuangtai', '0', '0', '10', '2015-08-05 17:23:46', '2015-08-05 17:23:46', null), ('12', '10', '个人信息', '/admin/index/owner', 'gerenxinxi', '0', '0', '12', '2015-08-05 17:23:46', '2015-08-05 17:23:46', null), ('13', '10', '密码修改', '/admin/index/modifypwd', 'gerenxinxi', '0', '0', '14', '2015-08-05 17:23:46', '2015-08-05 17:23:46', null), ('14', '2', '就业指南', '/admin/content/employ', 'jiuyezhinan', '0', '0', '15', '2015-08-05 17:53:38', '2015-08-05 17:53:38', 'glyphicon glyphicon-edit'), ('15', '2', '充电加油', '/admin/content/teaches', 'chongdianjiayou', '0', '0', '21', '2015-08-05 17:53:38', '2015-08-05 17:53:38', 'glyphicon glyphicon-book'), ('16', '2', '评论管理', '/admin/index/comment', 'pinglunguanli', '0', '0', '0', '2015-08-05 17:53:38', '2015-08-05 17:53:38', 'glyphicon glyphicon-comment'), ('17', '2', '其他信息', '/admin/index/others', 'qitaxinxi', '0', '0', '0', '2015-08-05 17:53:38', '2015-08-05 17:53:38', 'glyphicon glyphicon-eye-open'), ('18', '14', '就业指南', '/admin/content/employ/index', 'jiuyezhinan', '0', '0', '16', '2015-08-05 18:04:24', '2015-08-05 18:04:24', ''), ('19', '14', '分类管理', '/admin/content/employ/category', 'fenleiguanli', '0', '0', '19', '2015-08-05 18:04:24', '2015-08-05 18:04:24', ''), ('20', '15', '充电加油', '/admin/content/teaches/index', 'chongdianjiayou', '0', '0', '22', '2015-08-05 18:04:24', '2015-08-05 18:04:24', ''), ('21', '15', '分类管理', '/admin/content/teaches/catgory', 'fenleiguanli', '0', '0', '25', '2015-08-05 18:04:24', '2015-08-05 18:04:24', ''), ('22', '16', '评论管理', '/admin/content/comment', 'pinglunguanli', '0', '0', '0', '2015-08-05 18:04:24', '2015-08-05 18:04:24', ''), ('23', '17', '新闻公告', '/admin/content/other/news', 'xinwengonggao', '0', '0', '0', '2015-08-05 18:04:24', '2015-08-05 18:04:24', ''), ('24', '17', '合作机构', '/admin/content/other/links', 'hezuojigou', '0', '0', '0', '2015-08-05 18:04:24', '2015-08-05 18:04:24', ''), ('25', '17', 'Banner管理', '/admin/content/other/banners', 'bannerguanli', '0', '0', '0', '2015-08-05 18:04:24', '2015-08-05 18:04:24', ''), ('26', '8', '权限管理', '/admin/setting/permission', 'quanxianguanli', '0', '0', '0', '2015-08-05 18:08:43', '2015-08-05 18:08:43', 'glyphicon glyphicon-user'), ('27', '8', '系统数据', '/admin/setting/datas', 'xitongshuju', '0', '0', '0', '2015-08-05 18:08:43', '2015-08-05 18:08:43', 'glyphicon glyphicon-hdd'), ('28', '26', '管理员', '/admin/setting/admin', 'guanliyuan', '0', '0', '0', '2015-08-05 18:10:54', '2015-08-05 18:10:54', ''), ('29', '26', '角色管理', '/admin/setting/roles', 'jueseguanli', '0', '0', '0', '2015-08-05 18:10:54', '2015-08-05 18:10:54', ''), ('31', '26', '菜单管理', '/admin/setting/menu', 'caidanguanli', '0', '0', '0', '2015-08-05 18:11:19', '2015-08-05 18:11:19', '');
COMMIT;

-- ----------------------------
--  Table structure for `qm_tags`
-- ----------------------------
DROP TABLE IF EXISTS `qm_tags`;
CREATE TABLE `qm_tags` (
  `tags_id` int(10) NOT NULL AUTO_INCREMENT,
  `tags_name` varchar(50) NOT NULL COMMENT '名称',
  `is_recomm` tinyint(1) NOT NULL DEFAULT '0' COMMENT '推荐 0:不是，1是。',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`tags_id`),
  KEY `tags_tags_name` (`tags_name`),
  KEY `tags_recomm` (`is_recomm`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `qm_tags`
-- ----------------------------
BEGIN;
INSERT INTO `qm_tags` VALUES ('1', '测试', '0', '2015-08-06 17:02:21', '2015-08-06 17:02:21'), ('2', '就业', '0', '2015-08-06 17:07:05', '2015-08-06 17:07:05'), ('3', '你好', '0', '2015-08-06 17:28:39', '2015-08-06 17:28:39'), ('4', '第二条', '0', '2015-08-06 17:28:39', '2015-08-06 17:28:39'), ('7', '第三条', '0', '2015-08-06 17:35:42', '2015-08-06 17:35:42'), ('8', '财经', '0', '2015-08-07 14:10:41', '2015-08-07 14:10:41'), ('9', '好', '0', '2015-08-07 17:34:03', '2015-08-07 17:34:03'), ('10', '得到的', '0', '2015-08-07 17:36:43', '2015-08-07 17:36:43'), ('11', '电力', '0', '2015-08-08 18:59:49', '2015-08-08 18:59:49'), ('12', '土建', '0', '2015-08-08 19:01:03', '2015-08-08 19:01:03'), ('13', '认证', '0', '2015-08-08 19:01:03', '2015-08-08 19:01:03');
COMMIT;

-- ----------------------------
--  Table structure for `qm_users`
-- ----------------------------
DROP TABLE IF EXISTS `qm_users`;
CREATE TABLE `qm_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(60) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `stripe_active` tinyint(4) NOT NULL DEFAULT '0',
  `stripe_id` varchar(255) DEFAULT NULL,
  `stripe_subscription` varchar(255) DEFAULT NULL,
  `stripe_plan` varchar(100) DEFAULT NULL,
  `last_four` varchar(4) DEFAULT NULL,
  `trial_ends_at` timestamp NULL DEFAULT NULL,
  `subscription_ends_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `qm_users`
-- ----------------------------
BEGIN;
INSERT INTO `qm_users` VALUES ('1', 'admin', '527134626@qq.com', '$2y$10$i/hzuTS8nN7DVCEDz1rOYOMh6VoCuLI6Jkm433bQIharB1jYer202', 'aKduph8A8foZyRjPFepcAcfQtX31jUbqJpgi9ChfYMuNB8nCRqRJMwZfA9JK', '2015-07-31 17:06:16', '2015-08-07 22:25:03', '0', null, null, null, null, null, null);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
